﻿CREATE PROCEDURE dbo.PRC_DELETE_ALL
AS
BEGIN
BEGIN TRAN
	DELETE FROM dbo.[UserScores]
	DELETE FROM dbo.[TemplateScores]
	DELETE FROM dbo.[Templates]
	DELETE FROM dbo.[Groups]	
	DELETE FROM dbo.[SystemUsers]

	IF @@ERROR >0
	BEGIN 
		ROLLBACK TRAN
	END
	ELSE
	BEGIN
		COMMIT TRAN
	END
END --PROCEDURE	